1、重写Repeater（修改过的，当只有一页的情况时，只显示Total页数及共有多少条目，不会显示上一页，下一页等）:
View Code using System.ComponentModel;using System.Web.UI;[assembly: TagPrefix("MyRepeater.Control", "MyRepeater")]namespace MyRepeater{ /// /// JRepeater控件 /// [DefaultProperty("Text"), ToolboxData(" <{0}:Repeater ID=\"Rep_List\" runat=server EnableViewState=\"false\" OnPreRender=\"Rep_List_PreRender\"> -
-
-
")] public class Repeater : System.Web.UI.WebControls.Repeater { public bool ShowPagingWhenItemLessThanPageSize { get; set; } private int _recordcount = 0; private int _pagesize = 0; private string _pagelink = ""; private int _currentpage = 1; private string _urlSearchPrex = null; /// /// constructure /// public Repeater() { this.ShowPagingWhenItemLessThanPageSize = true; } #region _ [Bindable(true), Category("Data"), DefaultValue("1"), Description("totalCount")] public int RecordCount { get { return _recordcount; } set { _recordcount = value; } } [Bindable(true), Category("Data"), DefaultValue("1"), Description("pagesize")] public int PageSize { get { return _pagesize; } set { _pagesize = value; } } [Bindable(true), Category("Data"), DefaultValue(""), Description("currentLink")] public string PageLink { get { return _pagelink; } set { _pagelink = value; } } [Bindable(true), Category("Data"), DefaultValue("1"), Description("currentPageIndex")] public int CurrentPage { get { return _currentpage; } set { _currentpage = value; } } public string UrlSearchPrex { get { return _urlSearchPrex; } set { _urlSearchPrex = value; } } #endregion /// /// output control to page /// /// protected override void Render(HtmlTextWriter output) { base.Render(output); if (this._recordcount <= this._pagesize) { output.WriteLine(" Total:1 page(s) " + this._recordcount + " record(s) "); return; } if (!(this._recordcount <= this._pagesize && !this.ShowPagingWhenItemLessThanPageSize)) { output.WriteLine(" " + Pagination(_recordcount, _pagesize, _currentpage, _pagelink, _urlSearchPrex) + " "); } } /// /// paging function /// /// total count /// /// /// /// 2、页面调用方法：
View Code 后台只需要把数据绑定；
3、常用高效数据库分页存储过程（借用的）：
View Code --高效分页存储过程 CREATE PROCEDURE [dbo].[GetListByPage]( @Table nvarchar(500), --表名 @Field nvarchar(500) = '*', --读取字段 @Where nvarchar(max) = NULL, --Where条件 @GroupBy nvarchar(500) = NULL, --分组 @OrderBy nvarchar(500)= NULL, --排序字段 @PrimaryKeyField nvarchar(50), --主键必需 @PageIndex int = 1, --开始页码 @PageSize int = 10, --页大小 @IsCount bit = 0 --返回记录总数 ------------------------------------------------------------------------------------------------ --当@IsCount为1时,将同时返回2张表，表0为记录总数，表1为查询结果 ------------------------------------------------------------------------------------------------ ) AS BEGIN ------------------------------------------------------------------------------------------------ DECLARE @strWhere nvarchar(500) --Where 条件 IF @Where IS NOT NULL AND @Where != '' --Where 条件 BEGIN SET @strWhere = ' WHERE ' + @Where + ' ' END ELSE BEGIN SET @strWhere = '' END ---------------------------------------------------------------------------------------------------- DECLARE @strGroupBy nvarchar(500) --GroupBy 条件 IF @GroupBy IS NOT NULL AND @GroupBy != '' --GroupBy 条件 BEGIN SET @strGroupBy = ' GROUP BY ' + @GroupBy + ' ' END ELSE BEGIN SET @strGroupBy = '' END ---------------------------------------------------------------------------------------------------- DECLARE @strOrderBy nvarchar(500) --OrderBy 条件 IF @OrderBy IS NULL OR @OrderBy = '' --OrderBy 条件 BEGIN SET @strOrderBy = ' ORDER BY ' + @PrimaryKeyField + ' DESC' END ELSE BEGIN SET @strOrderBy = ' ORDER BY ' + @OrderBy END ---------------------------------------------------------------------------------------------------- DECLARE @strSql nvarchar(max) --Sql 语句 --计算总行数 IF @IsCount = 1 BEGIN SET @strSql= 'SELECT Count (*) AS RecordCount FROM ' + @Table + @strWhere + @strGroupBy print @strSql EXEC sp_executesql @strSql --RETURN END ---------------------------------------------------------------------------------------------------- IF @PageIndex < 1 --第一页提高性能 BEGIN SET @PageIndex = 1 END IF @PageIndex = 1 BEGIN SET @strSql = 'SELECT TOP ' + str(@PageSize) + ' ' + @Field + ' FROM ' + @Table + @strWhere + @strGroupBy + @strOrderBy print @strSql EXEC sp_executesql @strSql RETURN END ---------------------------------------------------------------------------------------------------- DECLARE @STARTID nvarchar(50) DECLARE @ENDID nvarchar(50) SET @STARTID = convert(nvarchar(50),(@PageIndex - 1) * @PageSize + 1) SET @ENDID = convert(nvarchar(50),@PageIndex * @PageSize) SET @strSql = 'WITH MYTABLE AS (SELECT ROW_NUMBER() OVER (' + @strOrderBy + ') AS RowNumber,' + @Field + ' FROM '+ @Table + @strWhere + @strGroupBy + ') SELECT * FROM MYTABLE WHERE RowNumber BETWEEN ' + @STARTID + ' AND ' + @ENDID print @strSql EXEC sp_executesql @strSql -------------------------------------------------------------------------------------------------- END 4、有上面的存储过程的使用，同样可以在后台实现真分页